﻿CREATE TABLE [dbo].[NetRole] (
    [ID]       INT              IDENTITY (1, 1) NOT NULL,
    [Name]     NVARCHAR (20)    NOT NULL,
    [Ab]       VARCHAR (20)     NOT NULL,
    [AddDate]  DATETIME         NOT NULL,
    [Enable]   BIT              NOT NULL,
    [IfDelete] BIT              NOT NULL,
    [TenantID] UNIQUEIDENTIFIER NULL,
    [HardCode] NVARCHAR (20)    NULL,
    CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ([ID] ASC)
);




GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'角色表', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetRole';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'角色标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetRole', @level2type = N'COLUMN', @level2name = N'ID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'角色名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetRole', @level2type = N'COLUMN', @level2name = N'Name';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'名称缩写', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetRole', @level2type = N'COLUMN', @level2name = N'Ab';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'添加日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetRole', @level2type = N'COLUMN', @level2name = N'AddDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否启用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetRole', @level2type = N'COLUMN', @level2name = N'Enable';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否删除', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NetRole', @level2type = N'COLUMN', @level2name = N'IfDelete';

